Skip to main content
Loading...
Skip to article
  • Qualtrics Platform
    Qualtrics Platform
  • Customer Journey Optimizer
    Customer Journey Optimizer
  • XM Discover
    XM Discover
  • Qualtrics Social Connect
    Qualtrics Social Connect

Data Export Formats


Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!


About Export Formats

When you export responses from your project, you can choose a file type for your data. This page goes over each of the file types available.

Along top of the download data table window is a list of file formats: CSV, TSV, excel, XML, SPSS, Google Drive, User-submitted files, and Tableau

Qtip: Not all export formats on this page are included with all licenses. If you do not see one of these formats on your account and would like it added, please reach out to the Brand Administrator in your organization. If you are the Brand Administrator, you can reach out to your Account Executive.
Qtip: Although these file types are compatible with different software and use cases, once opened, they all organize data into rows and columns. To learn more about what the different rows and columns mean, see Understanding Your Dataset.

CSV

CSV (Comma Separated Values) is a text file type that can be opened in spreadsheet software such as Microsoft Excel. From Excel, a CSV file can be edited, viewed, or converted into other file types compatible with other statistical software.

CSV files cannot support customization in Excel such as sheets, highlights, column filtering, and other advanced changes. To use those features, you must change your file to another type.

However, CSV and TSV are compatible file formats for importing response data, contacts, and more into Qualtrics. See the Troubleshooting CSV/TSV Upload Issues support page if you are having trouble importing with these file types.

Overall view of CSV data export opened in a spreadsheet

Qtip: Though CSV files do not have a column limit, Excel does. Excel 2003 has a limit of 256 columns, Excel 2007 has a limit of 16000, and Excel 2010 has a limit of 16384 columns. Some surveys may have more variables than these. In these situations, the data will be stored in the downloaded CSV file, but cannot be displayed in Excel. If this is the case, you will need to find another program to view the data (Google Sheets, SPSS, SAS, STATA, etc.).

TSV

A TSV (Tab Separated Values) file is a simple text format for storing data in a tabular structure.

Each column is separated (delimited) by a tab. TSV is an alternative to the comma separated values (CSV) format and can be opened by Text Editors (such as Notepad) and spreadsheet programs (such as Excel). While CSV is the standard for numeric data and the English language alphabet, if your data contains other forms of writing and special characters, TSV is often the better choice.

Data export opened in a plain text editor and in a spreadsheet

TSV files cannot support customization in Excel such as sheets, highlights, column filtering, and other advanced changes. To use those features, you must change your file to another type. However, CSV and TSV are compatible file formats for importing response data, contacts, and more into Qualtrics.

Qtip: If you have trouble opening your TSV file with Excel, see our CSV/TSV Upload Issues page for troubleshooting guidelines.

Excel

When you export in Excel format, the resulting file will be in an XLSX format.

Excel file. Unlike CSV and TSV screenshots, you can see the column headers are grayed out and there are dropdown arrows you can use for advanced column filtering

Although CSV, TSV, and XML are all compatible with Excel, the default document format in Excel is generally XLSX. XLSX exports can support customization in Excel such as sheets, highlights, column filtering, and other advanced changes that the other available file types cannot.

Qtip: XLSX files cannot be imported back into Qualtrics.

XML

XML (Extensible Markup Language) is a general-purpose markup language that defines a set of rules for encoding documents. Files in XML format are readable by both computers and machines and are commonly used for putting your raw data into a database. It is also compatible with Excel.

Data download in XML format

SPSS

SPSS (Statistical Analysis Package) is a software used for statistical analysis. SPSS files download in SAV format.

Data export opened in SPSS

If you’re having difficulty with international characters in your file and you’re using SPSS version 16 or later, you can try changing the Character Encoding for Data and Syntax setting to Unicode.

Qtip: For support with SPSS, see IBM®’s support resources.

Change Character Encoding for Data and Syntax

  1. Close any open datasets.
  2. Go to the SPSS Edit menu.
  3. Select Options.
  4. In the general tab under Character Encoding for Data and Syntax, choose Unicode.
  5. Click OK.

Qualtrics encodes international characters using the unicode UTF-8 character set. Unfortunately, old versions of SPSS (SPSS Version 15 and earlier) do not support unicode. You may want to consider upgrading to a newer version of SPSS.

SPSS Syntax Files & Corresponding Data Files

"More Options" available for SPSS files

2 additional file formats are available in the More Options for SPSS exports: SPSS Syntax File and Corresponding Data. The syntax file and corresponding data can be used to build the SPSS file after download. However, please note that prior SPSS knowledge is needed to do this. Qualtrics Support is unable to help with SPSS file parsing.

If you are looking for a simple SPSS file, we recommend downloading the standard SPSS file format.

Google Drive

The Google Drive export option allows you to export your data as a Google Sheet to Google Drive. To use this feature, you must have a Google account to link to your Qualtrics account. For more information about linking your account and exporting your data, read our page on Exporting Response Data to Google Drive.

User Submitted Files

If you used the file upload, screen capture, video response, or signature question type in your survey, you can use the User Submitted Files option to download all respondent-uploaded files at once. They will download to your computer in a .zip file and will include the original file names and the response ID for each response submitted.

image of the data export window. the Export User Submitted Files export option is selected

Tableau

Warning: This export format is available only if you have the Tableau Extension enabled for your account. If you’re interested in this feature, please reach out to your Account Team.

Tableau is a data analysis software. With our extension, you can send Qualtrics data directly to Tableau.

For more information, visit our Tableau extension page.

JSON and NDJSON

Warning: This export format is available only with the API Extension.

JSON (Javascript Object Notation) and NDJSON (newline delimited JSON) exports are only available through our API. See our API documentation on Surveys Response Import/Export API. File type is set during the Start Response Export step.

Exporting Data in Different Project Types

You can export response data in many different types of projects. The steps and options described on this page apply to the following project types:

There are a few other types of projects where you can export response data. However, these exports do not support the same file types listed above.

Different File Types Supported by Different Projects

Qtip: While other projects, like dashboards and directories, may also allow you to export data, this support page is solely focused on how to export response data from Data & Analysis. For steps on exporting other kinds of data across the XM platform, try narrowing your support site search.

FAQs